Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / auto increment id
Ask Question

Auto Increment ID

Pawan kumar 18346 22 Feb 2011
Sir i want to know that -how to make autoincrement id  in asp.net/C# with out using store-procedure in sql..
can it make by a Method or Function in .net ?.
asp.net asp.net
Updated 18 Nov 2013
Pawan kumar
Pawan kumar

Other

Message

6 Answers

mahesh kasar
mahesh kasar 18 Nov 2013
Report Abuse
use this code
http://sourcecodemaster.blogspot.in/2013/11/auto-increment-id-in-cnet.html
Horas Panjaitan
Horas Panjaitan 22 Mar 2013
Report Abuse
hi Sheen Buhay
What if I change integer code as K001
please help me
Anonymous User
Anonymous User 25 Oct 2011
Report Abuse
Hi Sheen Buhay,
Debug your code and check what value you have in dr[0].ToString(). I thing you might be getting Alphabets or symbols.
Suggestion: Don't just copy and paste the code snippet provided in the forum as those are not generalize, those are specific set of code used to accomplish a specific task. Please do modify the code according to your requirement.
Thanks
Sheen Buhay
Sheen Buhay 24 Oct 2011
Report Abuse
Hi Mr. Singh,
I followed your snippet however I am getting an error "Input string was not in a correct format." Highlighted in red.
Here's the snippet
if (dr.Read())
                        {
                            string d = dr[0].ToString();
                            if (d == "")
                            {
                                txtstudid.Text = strTesda;
                            }
                            else
                            {
                                r = Convert.ToInt32(dr[0].ToString());
                                r = r + 1;
                                txtstudid.Text = r.ToString();
                            }

Any idea why it causes this error? Thanks.

Uttam Misra
Uttam Misra 22 Feb 2011
Report Abuse
Pawan are you talking about Auto Increment ID in SQLServer? If yes then follow these steps without creating any method..
1.Open SQl Server Management Studio Express.
2.Go to your Database.
3.Rigth click on your Database Table Name.
4.Then Click on Modify.
5.In modify window click on your " ID" column Name.
6.Change its Data Type to int.
7.Then go to Column Prorerties below.
8.Under the "Indentity Specifications" nodes you will see (Is Indentity).
8.Set this property "Yes".
Sachindra Singh
Sachindra Singh 22 Feb 2011
Report Abuse
Hello pawan, i hope this code will help you
{
    public void Autogenrate() 
    { 
        int r; 
        try 
        { 
          con = new SqlConnection("data source=XYZ; user id=ABC; password=***; initial catalog=Detail"); 
       con.Open(); 
            SqlCommand cmd = new SqlCommand("Select max(id) from empp1", con); 
            SqlDataReader dr = cmd.ExecuteReader(); 
            if (dr.Read()) 
            { 
                string d = dr[0].ToString(); 
                if (d == "") 
                { 
                    id.Text = "1001";//set the value in textbox which name is id 
                } 
                else 
                { 
                    r = Convert.ToInt32(dr[0].ToString()); 
                    r = r + 1; 
                    id.Text = r.ToString(); 
                } 
            } 
            con.Close(); 
            con.Open(); 
          cmd.CommandText = "insert empp1 values('" + id.Text + "','" +   txtName.Text + "','" + txtCity.Text + "')"; 
            cmd.ExecuteNonQuery(); 
        } 
        catch (Exception ex) 
        { 
            Response.Write("<script>alert("+ex.Message+")</script>"); 
        } 
        finally 
        { 
            con.Close(); 
        }

advertising